QC Results
Event QC
Check there is Seedling Data for all Events
Check there is Tree Data for all Events
Tree QC
Check that all the Stem Letters are Letters
No errors
Check if Cause of Death is missing or a non-Valid Cause of Death
Check if Height is Missing or Three Standard Deviations Greater than Median
Check Height Difference
Check for Trees that have a height change greater than 33% between visits
Check if DBH is Missing or Three Standard Deviations Greater than Median
Check DBH Difference
Check for Trees that have a DBH change greater than 33% between visits
Check for Recently Dead PIAL Trees with a Null Mortality Year
Check Cone Count
Return list of trees where female cones exist but there is no cone count or where female cones do not exist but cone count is populated
Check Crown Health
Return list of trees who’s crown health isn’t a domain value or live PIAL trees with missing crown health
Check Lower Crown Kill
Return a list of trees whose lower crown kill is more than 100% or alive PIAL trees that have a null lower crown kill but are not null in both upper and middle crown kill percents
Check Middle Crown Kill
Return a list of trees whose middle crown kill is more than 100% or live PIAL trees that have a null middle crown kill but are not null in both upper and lower crown kill percents
No errors
Check Upper Crown Kill
Return a list of trees whose upper crown kill is more than 100% or live PIAL trees that have a null upper crown kill but are not null in both middle and lower crown kill percents
Check Subplot Numbers are between 1 and 5
No errors
Check if Vitality is Missing or a non-Valid Domain Value
Check Lower Bole Cankers
Return a list of trees with non-valid responses in the lower bole canker columns
Check Middle Bole Cankers
Return a list of trees with non-valid responses in the middle bole canker columns
Check Upper Bole Cankers
Return a list of trees with non-valid responses in the upper bole canker columns
Check Lower Branch Cankers
Return a list of trees with non-valid responses in the lower branch canker columns
Check Middle Branch Cankers
Return a list of trees with non-valid responses in the middle branch canker columns
Check Upper Branch Cankers
Return a list of trees with non-valid responses in the upper branch canker columns
Check Species
Return list of trees with missing or blank scientific names
Check that Trees aren’t listed as Recently Dead Twice
Seedling QC
Check for Plots that do not have 9 Subplots
Check Subplot Numbers are between 1 and 9
No errors
Check that Cause of Death is a Valid Domain Value
Check that Vitality is a Valid Domain Value
Check Species
Return list of trees with missing or blank scientific names
Check Height Classes
Return a list of seedlings that are alive but the height class does not match domain values